﻿<%@ Page Title="" Language="C#" MasterPageFile="~/StatisticPage/StatisticMaster.Master" AutoEventWireup="true" CodeBehind="KQTD.aspx.cs" Inherits="FPTPages.StatisticPage.KQTD" %>
<asp:Content ID="Content1" ContentPlaceHolderID="MainContent" runat="server">
<h1 class="title">Kết quả trận đấu</h1>
<p>Post by <a href="#">VuPTT</a></p>
<hr />
    <asp:GridView ID="gdvKQTD" runat="server" AllowSorting="True" 
        AutoGenerateColumns="False" BackColor="#DEBA84" BorderColor="#DEBA84" 
        BorderStyle="None" BorderWidth="1px" CellPadding="3" CellSpacing="2" 
        DataKeyNames="MatchID" DataSourceID="SqlDataSource1">
        <Columns>
            <asp:BoundField DataField="MatchID" HeaderText="MatchID" ReadOnly="True" 
                SortExpression="MatchID" />
            <asp:BoundField DataField="Home" HeaderText="Home" SortExpression="Home" />
            <asp:BoundField DataField="HomeScore" HeaderText="HomeScore" 
                SortExpression="HomeScore" />
            <asp:BoundField DataField="Away" HeaderText="Away" 
                SortExpression="Away" />
            <asp:BoundField DataField="AwayScore" HeaderText="AwayScore" 
                SortExpression="AwayScore" />
            <asp:BoundField DataField="PlayDate" HeaderText="PlayDate" 
                SortExpression="PlayDate" />
        </Columns>
        <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
        <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
        <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
        <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
        <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
        <SortedAscendingCellStyle BackColor="#FFF1D4" />
        <SortedAscendingHeaderStyle BackColor="#B95C30" />
        <SortedDescendingCellStyle BackColor="#F1E5CE" />
        <SortedDescendingHeaderStyle BackColor="#93451F" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ProjectDatabaseConnectionString2 %>" 
        
        SelectCommand="SELECT [MatchID], [Home], [HomeScore], [Away], [AwayScore], [PlayDate] FROM [MatchSchedule] WHERE ([Played] = @Played)">
        <SelectParameters>
            <asp:Parameter DefaultValue="true" Name="Played" Type="Boolean" />
        </SelectParameters>
    </asp:SqlDataSource>
    <br />
    <hr />
    <asp:Label ID="Label1" runat="server" Text="References:" Width="100px"></asp:Label>
    <asp:GridView ID="gdvReferences" runat="server" AutoGenerateColumns="False" 
        BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" 
        CellPadding="3" CellSpacing="2" DataKeyNames="TeamID" 
        DataSourceID="SqlDataSource2" Width="260px">
        <Columns>
            <asp:BoundField DataField="TeamID" HeaderText="TeamID" ReadOnly="True" 
                SortExpression="TeamID" />
            <asp:BoundField DataField="TeamName" HeaderText="TeamName" 
                SortExpression="TeamName" />
        </Columns>
        <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
        <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
        <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
        <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
        <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
        <SortedAscendingCellStyle BackColor="#FFF1D4" />
        <SortedAscendingHeaderStyle BackColor="#B95C30" />
        <SortedDescendingCellStyle BackColor="#F1E5CE" />
        <SortedDescendingHeaderStyle BackColor="#93451F" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ProjectDatabaseConnectionString2 %>" 
        SelectCommand="SELECT * FROM [TeamReference]">
    </asp:SqlDataSource>
<br />

</asp:Content>
